package com.black.platform.dictionary.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.black.platform.dictionary.po.Dictionary;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


@Mapper
public interface DictionaryMapper extends BaseMapper<Dictionary> {

    @Select("<script>" +
            "SELECT code,name,code_type codeType FROM dictionary WHERE code IN" +
            "(SELECT code_type FROM dictionary where code_type IS NOT NULL)" +
            "</script>")
    List<Dictionary> getAllCodeType();
}
